Stored Procedures [dbo].[BAECartBillingUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@CartBillingIdint4
@CartItemIdint4
@ProductCodevarchar(256)256
@Titlevarchar(256)256
@DuesTypevarchar(256)256
@Pricemoney8
@IDvarchar(10)10
SQL Script

create procedure [dbo].[BAECartBillingUpdate] @CartBillingId as
int,    
    @CartItemId AS int,    
    @ProductCode AS varchar(256),    
    @Title AS varchar(256),    
    @DuesType AS varchar(256),    
    @Price AS money,
    @ID AS varchar(10)
AS
    UPDATE CartBilling
    SET     CartItemId = @CartItemId,
        ProductCode = @ProductCode,
        Title = @Title,
        DuesType = @DuesType,
        Price = @Price,
        ID = @ID
    WHERE CartBillingId = @CartBillingId;


GO
Uses